{"text_format":"3","workbook":"xlsx","n_sheets":18,"sheets":["Overall","WPR_Report_1_Summaries","WPR_Report_2_Errorflags","WPR_errorflag_explanations","WPR_Report_3.0 Zero_payment","WPR_Report_3.1 EA or 3.2 HL","WPR_Report_3.3 work hours>80","WPR_Report_3.4 Disregarded_part","WPR_Report_4.NumDen","SSP cases<$35","Combined_WPR_Report_1_Num","Combined_WPR_Report_2.WPR","TL_Report_1_Months Distribution","TL_Report_2_exemptions","TL_Report_3_Errorflags","TL_Report_4_Over60Months","invalid_SSNs","Invalid_age"],"not_rendered":{"images":12,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Overall","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"merged":[[0,0,0,4]]}
["TANF&SSP WPR &TL Monthly Reports"]
[]
[]
["TANF WPR Reports","1. TANF Monthly Cases Summary ",null,"SSP WPR Reports","1.SSP Monthly Cases Summary "]
[null,"2. Errorflags",null,null,"2. Errorflags"]
[null,"3. TANF cases review",null,null,"3. SSP cases review"]
[null,"  3.0 Zero Payment ",null,null,"  3.0 Zero Payment "]
[null,"  3.1 Excuse Absence hours >4 hours",null,null,"  3.1 Excuse Absence hours >4 hours"]
[null,"  3.2 Holiday hours > 4 or 6 hours ",null,null,"  3.2 Holiday hours > 4 or 6 hours "]
[null,"  3.3 Work Hours > 80 hours",null,null,"  3.3 Work Hours > 80 hours"]
[null,"  3.4 Disregarded but met work requirement Cases",null,null,"  3.4 Disregarded but met work requirement Cases"]
[null,"4. numerator/denominator and rate",null,null,"4.  numerator/denominator and rate"]
[{"$nulls":4},"5.  number of cases each month that with  cash_assistance less than $35"]
[]
[]
["TANF&SSP Combined","1. TANF&SSP numerator/denominator and rate"]
[null,"2. TANF and SSP combined WPRs"]
[]
[]
["TimeLimit Report","Time Limit Reports"]
[null," 1. Countable Months"]
[null," 2. Exemption Distribution"]
[null," 3. TimeLimit Errorflags"]
[null," 4. Number of Cases with over 60 months"]
[]
["extras","1. invalid_SSNs"]
[null,"2.invald DOBs or age inappropriations"]

{"sheet":"WPR_Report_1_Summaries","index":1,"n_rows":7,"n_cols":4,"rows_kept":7}
[]
[null,"Name ","file type","Notes"]
[null,"TANFXX_summary_FY202X","Rich Text","Monthly summary tables for "]
[null,"SSPXX_summary_FY202X","Rich Text","cases in WPRs"]
[]
[]
[null,"XX: Fips_code of state"]

{"sheet":"WPR_Report_2_Errorflags","index":2,"n_rows":67,"n_cols":4,"rows_kept":67,"merged":[[66,1,66,3],[67,1,67,2]]}
[]
[null,"Name ","file type","Notes"]
[null,"TANFXX_EF_FY202X","pdf","if state didn't have any errorflag, this wouldn't be"]
[null,"SSPXX_EF_FY202X","pdf","generated"]
[]
[null,"XX: Fips_code of state"]
[]
[null,"Variable Dictionary"]
[null,"FIPS","=","Fips Code"]
[null,"rpt_month_year","=","Report Year Month"]
[null,"STRATUM","=","Stratum"]
[null,"CASEID","=","Case Number"]
[null,"TYPE_FAM","=","Type of Family in Particiaption (state reported)"]
[null,"ftype","=","Type of Family in Particiaption (OFA based on #of WEI)"]
[null,"N_WEI","=","# of Work Eligible Individuals"]
[null,"NWORK","=","=1 means met All-Family WPR"]
[null,"AF_WEI","=","Work Eligible Indicator"]
[null,"AF_famaff","=","Family Affiliation"]
[null,"af_age","=","adult's age"]
[null,"af_parent","=","if is a parent in 2P family, all-family, or not a parent"]
[null,"af_wps","=","Work Particiaption Status"]
[null,"AF_SSI","=","$ of SSI"]
[null,"AF_RECSSI","=","Recived SSI Yes/No"]
[null,"sanc_amt","=","$ amount of Sanction "]
[null,"work_SANC","=","Work sanction Yes/No"]
[null,"af_ncp","=","Non custodial Parent Yes/No"]
[null,"af_citz","=","Citizen/Alien status"]
[null,"youngest","=","the age of the youngest child"]
[null,"NDVEXEM","=","if exempt due to Domestic Violence "]
[null,"AFERRFG","=","All-family Errorflag for WPR"]
[null,"TPWORK","=","=1 means met 2P-Family WPR"]
[null,"p1_age","=","Age of the 1st parent"]
[null,"p1_wei","=","Work Eligible Indicator for 1st Parent"]
[null,"p1_wps","=","Work Particiaption Status for 1st parent"]
[null,"p2_age","=","Age of the 2nd parent"]
[null,"P2_wei","=","Work Eligible Indicator for 2nd Parent"]
[null,"p2_wps","=","Work Particiaption Status for 1st parent"]
[null,"TPERRFG","=","2P-family Errorflag for WPR"]
{"$rows_empty":28}
[null,"Explanations for WPR errorflags of all-family and two-parent family"]

{"sheet":"WPR_errorflag_explanations","index":3,"n_rows":24,"n_cols":9,"rows_kept":24,"merged":[[1,1,1,3],[1,6,1,8],[18,1,18,3],[18,6,18,8]]}
[]
[null,"TANF All-family ErrorFlags",{"$nulls":4},"SSP All-family ErrorFlags"]
[null,"AFERRFG","MEANING","How the error is treated  when All-family WPR is calculated",null,null,"AFERRFG","MEANING","How the error is treated  when All-family WPR is calculated"]
[null,1,"Item #12 type_fam not in 1, 2 or 3","Consider item#12 as 1- 3 based on the # of WEIs",null,null,1,"Item #9 type_fam not in 1,2 or 3","Consider item#9 as 1- 3 based on the # of WEIs"]
[null,2,"Item #12 Type_fam = 1, but no work-eligible individual found.","item#12 = 1 and there was no wei (item#48 is between 1 to 5). Consider Type_fam=3",null,null,2,"Item #9 Type_fam = 1, but no work-eligible individual found.","item#9 = 1 and there was no wei (item#41 is between 1 to 5). Consider Type_fam=3"]
[null,3,"No child under age one, or not a single parent","item #49 = 1 and no child under 1 year; or the parent is not a single parent. \nConsider #49 = 18",null,null,3,"No child under age one, or not a single parent","item #42 = 1 and no child under 1 year; or the parent is not a single parent.\nConsider #42 = 18"]
[null,4,"Is not a teen head-of-household or married teen (spouse of head-of-household) engaged in satisfactory school attendance.","item #49 = 15, but one of the following didn’t meet:\n1. age<=19 and\n2.(item #38 = 01 or 02 hoh or spouse of hoh)\n3. sum of (items #60.a. + 60.b. + 60.c.)  > 0) satisfactory school attendance for individuals with no high school diploma or certificate of high school equivalency.\nConsider #49=18\n\n",null,null,4,"Is not a teen head-of-household or married teen (spouse of head-of-household) engaged in satisfactory school attendance.","item #42 = 15, but one of the following didn’t meet:\n1. age<=19 and\n2.(item #34 = 01 or 02 hoh or spouse of hoh)\n3. sum of (items #53.a. + 53.b. + 53.c.)  > 0) satisfactory school attendance for individuals with no high school diploma or certificate of high school equivalency.\nConsider #42 = 18\n"]
[null,5,"Is not a teen head-of-household or married teen (spouse of head-of-household) engaged in education directly related to employment.","item #49 = 16, but one of the following didn’t meet: \n1. age<=19 and\n2.(item #38 = 01 or 02 hoh or spouse of hoh)\n3. sum of (items #59.a. + 59.b. + 59.c.)  >=20) education directly related to employment for an individual with no high school diploma or certificate of high school equivalency.\nConsider #49=18",null,null,5,"Is not a teen head-of-household or married teen (spouse of head-of-household) engaged in education directly related to employment.","item #42 = 16, but one of the following didn’t meet:\n1. age<=19 and\n2.(item #34 = 01 or 02 hoh or spouse of hoh)\n3. sum of (items #52.a. + 52.b. + 52.c.)  >=20) education directly related to employment for an individual with no high school diploma or certificate of high school equivalency.\nConsider #42 = 18\n"]
[null,6,"No child under age six, or core hours<20","item #49 = 17, but no child under 6 or the core work activities <20 hours.\nConsider #49 =18",null,null,6,"No child under age six, or core hours<20","item #42 = 17, but no child under 6 or the core work activities <20 hours.\nConsider #42 = 18"]
[null,7,"item#48=7, but the adult is a citicizen","item#48=7, not a WEI due to immigration status, but item#42=1, is a citizen",null,null,7,"item#41=7, but the adult is a citicizen","item#41=7, not a WEI due to immigration status, but item#38=1, is a citizen"]
[null,8,"WPS = 99, but there is at least one work-eligible individual. ","item #49 = 99 but item #48 (wei) between 1 to 5\nConsider #49=18",null,null,8,"WPS = 99, but there is at least one work-eligible individual. ","item #42 = 99 but item #41 (wei) between 1 to 5.\nConsider #42 = 18"]
[null,9,"TYPE_FAM = 3 but there is at least one work-eligible individual.","item #12 = 3 but there is WEI(item #48 (wei) should between 1 to 5).\nConsider #12 as 1 or 2 based on #of WEIs",null,null,9,"TYPE_FAM = 3 but there is at least one work-eligible individual.","item #9 = 3 but there is WEI (item #41 (wei) should between 1 to 5).\nConsider #9 as 1 or 2 based on #of WEIs"]
[null,10,"Family affiliation (item#30=1) recipient or (item#30=2) non-recipient parent , should be a work-eligible individual ","item #30 =1 (recipient) or 2 (non-recipient parent),  but item#48 (wei)  is not between 1 to 5. \nConsider #48 =1(is WEI)",null,null,10,"Family affiliation (item #26) =1 as recipient or (item#30=2) non-recipient parent , should be a work-eligible individual ","item #26 =1 (recipient) or 2  (non-recipient parent),  but item#41 (wei) is not between 1 to 5. \nConsider #41 =1(is WEI)"]
[null,11,"Individual is not an alien and is a work-eligible individual.  ","item #48 work-eligible individual indicator =7 and citizenship/alienage(#42) =1 or 2.\nConsider #48=1(is WEI)",null,null,11,"Individual is not an alien and is a work-eligible individual.  ","item #41work-eligible individual indicator =7 and citizenship/alienage(#38) =1 or 2.\nConsider #41 =1(is WEI)"]
[null,12,"Individual is not an SSI/SSDI/AABD recipient(item#36) and is a work-eligible individual.  ","item #48 = 8 and (item #36.e. = 2 or item #66.c. = 0) or item #48 = 8  and (item 36.a 36.b or 36.c=0)).\nConsider #48=1(is WEI)",null,null,12,"Individual is not a SSI/SSDI/AABD recipient(item#32) and is a work-eligible individual.  ","item #41 = 8 and (item #32.e. = 2 and item #59.c. = 0) or item #41 = 8  and (item 32.a 32.b or 32.c=0)).\nConsider #41 =1(is WEI)"]
[null,13,"item#49 WPS=2 but family not sanctioned.  ","item #49 = 2 and not ((item #30 = 1 and item #26.a.ii. = 1 and item #26.a.i. > 0) or (item #30 = 2 and item #26.a.ii. = 1 and item #26.a.i. > 0 and item #48 = 2)).\nConsider #49=18",null,null,13,"item#42 WPS=2 but family not sanctioned.  ","item #42 = 2 and not ((item #26 = 1 and item #24.a.ii. = 1 and item #24.a.i. > 0) or (item #26 = 2 and item #24.a.ii. = 1 and item #24.a.i. > 0 and item #41 = 2)).\nConsider #42 =18"]
[null,14,"item #48(WEI)= 11, but age>19 or is HoH","item #48 = 11 (not a WEI because a minor parent who is not a head-of -household) but (item #38(HoH) =1, or 2 or age>19).\nConsider #48=1(is WEI)",null,null,14,"item #41(WEI) = 11, but age>19 or is HoH ","item #41 = 11(not a WEI because a minor parent who is not a head-of -household) but (item #34(HoH) =1, or 2 or age>19).\nConsider #41 =1(is WEI)"]
[]
[null,"TANF 2-Parent-family ErrorFlags",{"$nulls":4},"SSP 2-Parent-family ErrorFlags"]
[null,"TPERRFG","MEANING","How the error is treated  when 2P WPR is calculated",null,null,"TPERRFG","MEANING","How the error is treated  when 2P WPR is calculated"]
[null,1,"Item#12 = 2 (2-parent family), but there was less than 2 WEIs found","item#12 = 2 and no two WEIs (item#48 <6).\nConsider #12=1(all-family WPR)",null,null,1,"Item#9 = 2 (2-parent family), but there was less than two WEIs found","item#9 = 2 and no two WEIs (item#41 <6).\nConsider #9=1(all-family WPR)"]
[null,2,"There are at least two WEI parents in the family but type of family (item#12) not =2","two parents’item#48 between 1-5 and both parent’s item#39 = 1(parent in 2-parent work participation).\nConsider item#12= 2(2P WPR)",null,null,2,"There are at least 2 WEI parents in the family but type of family (item#9) not =2","two parents’item#41 between 1-5 and both parent’s item#35 = 1(parent in 2-parent work participation).\nConsider item#9= 2(2P WPR)"]
[null,3,"Can’t be disregarded (item #49=2) because not sanctioned.","1st parent not sanctioned or sanction amount=0(item#26); or 2nd parent not sanctioned or sanction amount=0 (item#26).\nConsider this 2P case is not sanctioned",null,null,3,"Can’t be disregarded (item #42=2) because not sanctioned.","1st parent not sanctioned or sanction amount=0(item#24); or 2nd parent not sanctioned or sanction amount=0 (item#24).\nConsider this 2P case is not sanctioned"]
[null,4,"Disregard for reason (item#49=1) is not applicable for a two-parent family.","item #12 = 2(2 parent family), item #49 can’t be 1 (disregarded for single parent with child under 1). Consider this 2P case is not disregarded\n",null,null,4,"Disregard for reason (item#42=1) is not applicable for a two-parent family.","item #9 = 2(2 parent family), item #42 can’t be 1 (disregarded for single parent with child under1).\nConsider this 2P case is not disregarded"]

{"sheet":"WPR_Report_3.0 Zero_payment","index":4,"n_rows":17,"n_cols":4,"rows_kept":17}
[]
[]
[null,"Name ","file type","Notes"]
[null,"TANFXX_review_FY202X","pdf","Zero Payment"]
[null,"SSPXX_review_FY202X","pdf","Table  3.0"]
[]
[]
[null,"Variable Dictionary"]
[null,"FIPS","=","Fips Code"]
[null,"rpt_month_year","=","Report Year Month"]
[null,"CASEID","=","Case Number"]
[null,"Cash assistance $"]
[null,"TANF child care $"]
[null,"Transportation $"]
[]
[]
[null,"XX: Fips_code of state"]

{"sheet":"WPR_Report_3.1 EA or 3.2 HL","index":5,"n_rows":23,"n_cols":8,"rows_kept":23}
[]
[null,"Name ","file type","Notes",null,"Name ","file type","Notes"]
[null,"TANFXX_review_FY202X","pdf","Excuse Absence> 4 hours",null,"TANFXX_review_FY202X","pdf","Holiday Hours > 4 or 6 hours"]
[null,"SSPXX_review_FY202X","pdf","Table  3.1",null,"SSPXX_review_FY202X","pdf","Table 3.2"]
[]
[null,"Variable Dictionary"]
[null,"FIPS","=","Fips Code"]
[null,"rpt_month_year","=","Report Year Month"]
[null,"STRATUM","=","Stratum"]
[null,"CASEID","=","Case Number"]
[null,"work exp","=","Work Experience"]
[null,"job search","=","Job Search and Job Readiness Assistance"]
[null,"comm serv","=","Community Service Programs"]
[null,"voc.ed","=","Vocational Educational Training"]
[null,"job skills","=","Job Skills Training"]
[null,"ed.no.hs.dipl","=","Education Directly Related to Employment for Individuals With No High School Diploma or Certificate of High School Equivalency "]
[null,"school attend","=","Satisfactory School Attendance for Individuals With No High School Diploma or Certificate of High School Equivalency "]
[null,"provide cc","=","Providing Child Care Services to an Individual who is participating in a Community Service Program"]
[]
[]
[null,"XX: Fips_code of state"]
[null,"P1 - Parent 1 in 2P family"]
[null,"P2 - Parent 2 in 2P family"]

{"sheet":"WPR_Report_3.3 work hours>80","index":6,"n_rows":29,"n_cols":4,"rows_kept":29}
[]
[null,"Name ","file type","Notes"]
[null,"TANFXX_review_FY202X","pdf","Table 3.3"]
[null,"SSPXX_review_FY202X","pdf","total work hours over 80/week"]
[]
[]
[null,"Variable Dictionary"]
[null,"FIPS","=","Fips Code"]
[null,"rpt_month_year","=","Report Year Month"]
[null,"STRATUM","=","Stratum"]
[null,"CASEID","=","Case Number"]
[null,"unsub employ","=","Unsubsidized Employment"]
[null,"sub.priv.employ","=","Subsidized Private-Sector Employment"]
[null,"sub.pub.employ","=","Subsidized Public-Sector Employment"]
[null,"work exper","=","Work Experience"]
[null,"ojt","=","On-the-Job Training"]
[null,"job search","=","Job Search and Job Readiness Assistance"]
[null,"comm.serv","=","Community Service Programs"]
[null,"voc ed","=","Vocational Educational Training"]
[null,"job skills","=","Job Skills Training"]
[null,"ed.no.hs","=","Education Directly Related to Employment for Individuals With No High School Diploma or Certificate of High School Equivalency "]
[null,"school attend","=","Satisfactory School Attendance for Individuals With No High School Diploma or Certificate of High School Equivalency "]
[null,"provide cc","=","Providing Child Care Services to an Individual who is participating in a Community Service Program"]
[null,"other activ","=","Other Work Activities"]
[]
[]
[null,"XX: Fips_code of state"]
[null,"P1 hours - Parent 1's hours in 2P family"]
[null,"P2 hours - Parent 2's hours in 2P family"]

{"sheet":"WPR_Report_3.4 Disregarded_part","index":7,"n_rows":24,"n_cols":4,"rows_kept":24}
[]
[null,"Name ","file type","Notes"]
[null,"TANFXX_review_FY202X","pdf","Table 3.4. Cases that WPS coded as disregarded"]
[null,"SSPXX_review_FY202X","pdf","but met All family or 2P family Work requirement"]
[]
[]
[null,"Variable Dictionary"]
[null,"FIPS","=","Fips_code"]
[null,"rpt_month_year","=","Report Year Month"]
[null,"STRATUM","=","Stratum code"]
[null,"CASEID","=","Case Number"]
[null,"TYPE_FAM","=","Type of Family"]
[null,"ftype","=","Family Type in Particiaption calculated"]
[null,"N_WEI","=","Number of Work-Eligible Individuals"]
[null,"NWORK","=","1 means counted as participating for overall rate"]
[null,"AF_WPS","=","Work Participation Status"]
[null,"NDCRD_PART","=","1 means disregarded but met all-family WPR"]
[null,"TPWORK","=","1 means counted as participating for 2P rate"]
[null,"P1_WPS","=","Parent 1's Work Participation Status"]
[null,"P2_WPS","=","Parent 2's Work Participation Status"]
[null,"TPDCRD_PART","=","1 means disregarded but met 2P WPR"]
[]
[]
[null,"XX: Fips_code of state"]

{"sheet":"WPR_Report_4.NumDen","index":8,"n_rows":18,"n_cols":16,"rows_kept":18,"merged":[[1,3,1,11],[2,3,2,11],[3,3,3,11],[4,3,4,11],[6,2,6,9],[7,2,7,9],[12,1,12,15]]}
[]
[null,"Name ","file type","Notes"]
[null,"TANFXX_NUMDEN","pdf","a state that submits universe data may see non-integer"]
[null,"SSPXX_NUMDEN","pdf","numerator or denominator, that's because section 1 data "]
[{"$nulls":3},"doesn't match the aggregated data in section 3"]
[]
[null,null,"(TANF or SSP ) WPR Numerator/Denominator and Rate"]
[null,null,"For State: XXX in FY202X"]
[null,"FIPS","type","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Avg"]
[null,"XX","AllFamiliy_num",{"v":99,"d":"99.0"},{"v":88,"d":"88.0"},{"v":84,"d":"84.0"},{"v":94,"d":"94.0"},{"v":87,"d":"87.0"},{"v":74,"d":"74.0"},{"v":72,"d":"72.0"},{"v":74,"d":"74.0"},{"v":53,"d":"53.0"},50.1,62.1,66.1,75.3]
[null,"XX","AllFamiliy_den",{"v":641,"d":"641.0"},{"v":571,"d":"571.0"},{"v":549,"d":"549.0"},{"v":521,"d":"521.0"},{"v":499,"d":"499.0"},{"v":458,"d":"458.0"},{"v":431,"d":"431.0"},{"v":427,"d":"427.0"},{"v":416,"d":"416.0"},415.5,452.7,446.9,485.7]
[null,"XX","AllFamiliy_rate",15.4,15.4,15.3,{"v":18,"d":"18.0"},17.4,16.2,16.7,17.3,12.7,12.1,13.7,14.8,15.4]
[]
[null,"XX","TPFamily_num",0,0,0,0,0,0,0,0,0,0,0,0,"."]
[null,"XX","TPFamiliy_den",0,0,0,0,0,0,0,0,0,0,0,0,"."]
[null,"XX","TPFamiliy_rate",".",".",".",".",".",".",".",".",".",".",".",".","."]
[]
[null,"XX: Fips_code of state"]

{"sheet":"SSP cases<$35","index":9,"n_rows":12,"n_cols":4,"rows_kept":12,"merged":[[2,1,2,4],[3,2,3,3]]}
[]
[]
[null,"SSP families with cash assistance less than $35"]
[null,null,"State: xxxxx in FY2026"]
[]
[null,null,"RPT_MONTH_YEAR","Frequency"]
[null,null,202510,1]
[null,null,202511,2]
[null,null,202512,2]
[null,null,202601,4]
[null,null,202602,2]
[null,null,202603,3]

{"sheet":"Combined_WPR_Report_1_Num","index":10,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[1,3,1,11],[2,3,2,11],[4,2,4,9],[5,2,5,9],[10,1,10,15]]}
[]
[null,"Name ","file type","Notes"]
[null,"CMBXX_NUMDEN","pdf","Combined TANF and SSP Num/Den"]
[]
[null,null,"CMB WPR Numerator/Denominator and Rate"]
[null,null,"For State: XXX in FY202X"]
[null,"FIPS","type","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Avg"]
[null,"XX","AllFamiliy_num",{"v":99,"d":"99.0"},{"v":88,"d":"88.0"},{"v":84,"d":"84.0"},{"v":94,"d":"94.0"},{"v":87,"d":"87.0"},{"v":74,"d":"74.0"},{"v":72,"d":"72.0"},{"v":74,"d":"74.0"},{"v":53,"d":"53.0"},50.1,62.1,66.1,75.3]
[null,"XX","AllFamiliy_den",{"v":641,"d":"641.0"},{"v":571,"d":"571.0"},{"v":549,"d":"549.0"},{"v":521,"d":"521.0"},{"v":499,"d":"499.0"},{"v":458,"d":"458.0"},{"v":431,"d":"431.0"},{"v":427,"d":"427.0"},{"v":416,"d":"416.0"},415.5,452.7,446.9,485.7]
[null,"XX","AllFamiliy_rate",15.4,15.4,15.3,{"v":18,"d":"18.0"},17.4,16.2,16.7,17.3,12.7,12.1,13.7,14.8,15.4]
[]
[null,"XX","TPFamily_num",0,0,0,0,0,0,0,0,0,0,0,0,"."]
[null,"XX","TPFamiliy_den",0,0,0,0,0,0,0,0,0,0,0,0,"."]
[null,"XX","TPFamiliy_rate",".",".",".",".",".",".",".",".",".",".",".",".","."]
[]
[null,"XX: Fips_code of state"]

{"sheet":"Combined_WPR_Report_2.WPR","index":11,"n_rows":19,"n_cols":16,"rows_kept":19,"merged":[[1,3,1,7],[2,3,2,7],[4,5,4,8],[5,5,5,8],[6,4,6,10],[10,1,10,15],[13,1,13,15],[18,1,18,2]]}
[]
[null,"Name ","file type","Notes"]
[null,"WTRFXX_RTE","pdf","WPRs for Combined, SSP and TANF"]
[]
[{"$nulls":5},"FISCAL YEAR 202X"]
[{"$nulls":5},"XXX WORK PARTICIPATION RATE"]
[{"$nulls":4},"If there is '*' means the rate was adjusted by 30% limit"]
[null,"Rate","Overall/2 parent","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","AVG"]
[null,"COMBINED RATE","OVERALL",48.4,48.5,46.1,46.8,47.6,48.8,50.9,50.1,49.6,49.8,49.4,49.3,48.8]
[null,"COMBINED RATE","TWO PARENT",38.7,38.9,35.2,43,40.9,42.6,49.2,46.4,47.5,50.5,54.1,48.1,44.6]
[]
[null,"SSP RATE","OVERALL",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SSP RATE","TWO PARENT",0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TANF RATE","OVERALL",48.4,48.5,46.1,46.8,47.6,48.8,50.9,50.1,49.6,49.8,49.4,49.3,48.8]
[null,"TANF RATE","TWO PARENT",38.7,38.9,35.2,43,40.9,42.6,49.2,46.4,47.5,50.5,54.1,48.1,44.6]
[]
[]
[null,"XX: Fips_code of state"]

{"sheet":"TL_Report_1_Months Distribution","index":12,"n_rows":21,"n_cols":4,"rows_kept":21,"merged":[[1,3,1,7],[2,3,2,7],[6,3,6,7],[7,3,7,7],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,3,11,4],[14,3,14,7],[14,8,14,9],[15,3,15,5],[15,6,15,7],[15,8,15,9],[16,3,16,5],[16,6,16,7],[16,8,16,9],[17,3,17,5],[17,6,17,7],[17,8,17,9],[18,3,18,5],[18,6,18,7],[18,8,18,9],[19,3,19,7],[20,1,20,2],[20,3,20,7]]}
[]
[null,"Name ","file type","Notes"]
[null,"TIMELIMxx_FY202X","pdf","Table 1 - Received Federal TANF Assistance Months"]
[]
[]
[null,"Variable:"]
[null,"MONTH","=","Report year and month"]
[null,"Families","=","Total families"]
[null,"# of Adults","=","Numbers of adults"]
[null,"# of HoHs","=","Numbers of Head-of-Households"]
[null,"# of HoH recipients","=","Number of Head-of-Household recipients "]
[null,"0 Month","=","Received 0 month"]
[null,"1~12 Months","=","Received 1-12 months"]
[null,"13~24 Months","=","Received 13-24 months"]
[null,"25~36 Months","=","Received 25-36 months"]
[null,"37~48 Months","=","Received 37-48 months"]
[null,"49~59 Months","=","Received 49-59 months"]
[null,"60 Months","=","Received 60 months"]
[null,"60+ Months","=","Received over 60 months"]
[]
[null,"XX: Fips_code of state"]

{"sheet":"TL_Report_2_exemptions","index":13,"n_rows":20,"n_cols":4,"rows_kept":20,"merged":[[1,3,1,5],[2,3,2,5],[5,3,5,8],[6,3,6,8],[7,3,7,8],[8,3,8,8],[9,3,9,8],[10,3,10,8],[11,3,11,7],[18,1,18,7],[19,1,19,2],[30,3,30,10],[31,3,31,10],[32,3,32,10]]}
[]
[null,"Name ","file type","Notes"]
[null,"TLIMXX_EF_FY202X","pdf","Table 2  - Exemeptions"]
[]
[null,"Variables:"]
[null,"MONTH","=","Report year and month"]
[null,"Families","=","Total families"]
[null,"# of Adults","=","numbers of adults"]
[null,"# of HoHs","=","numbers of Head-of-Households"]
[null,"# of HoH recipients","=","number of Head-of-Household recipients "]
[null,"TLEX1","=","Not exempt"]
[null,"TLEX2","=","Non-HoH, exempt"]
[null,"TLEX3","=","Exempt, 60 or less months use state fund"]
[null,"TLEX4","=","Exempt, 60 or less months in indian country"]
[null,"TLEX6","=","Exempt, 60+ months use state fund"]
[null,"TLEX7","=","Exempt, 60+ months due to hardship"]
[null,"TLEX8","=","Exempt, 60+months due to domestic violence"]
[null,"TLEX9","=","60 or less months in Indian country"]
[null,"*TLEXn - is the time-limit exempt after TL errorflags are corrected. The totals of each category can be different from the totals based on what states reported to item#28"]
[null,"XX: Fips_code of state"]

{"sheet":"TL_Report_3_Errorflags","index":14,"n_rows":43,"n_cols":4,"rows_kept":43,"merged":[[1,3,1,5],[2,3,2,5],[5,3,5,8],[32,1,32,2],[34,2,34,7],[35,2,35,7],[36,2,36,7],[37,2,37,7],[38,2,38,7],[39,2,39,7]]}
[]
[null,"Name ","file type","Notes"]
[null,"TIMELIMXX_FY202Y","pdf","Table 3 -TL Errorflags"]
[]
[]
[null,"RPT_MONTH_YEAR","=","Report year and month"]
[null,"CASEID","=","CASEID"]
[null,"type_fam","=","type_family in Participation"]
[null,"Funding","=","Funding stream"]
[null,"FED_Months","=","Fed Timelimit Exemption "]
[null,"Family affiliation","=","Family affiliation"]
[null,"HoH","=","Head-of-household/spouse of HoH"]
[null,"FED_Months","=","Months Received Fed Assistance"]
[null,"TLERRFG","=","TimeLimit Errorflag"]
{"$rows_empty":18}
[null,"XX: Fips_code of state"]
[]
[null,"TLERRFG","Explanation and fix"]
[null,1,"item#28 federal time limit exemption is out of range, should be 01, 02, 03, 04, 06, 07, 08, or 09; or item#28=01 but federal time limit (item#44) more than 60 months\nCorrection: If number of months countable toward federal time limit (item#44) more than 60 months, and Funding stream item#8 =1 Federal-funded #item 28 should be “07”; if Funding stream item#8 =2 state funded, #28 should be 06. \nIf less than or equal to 60 months and and Funding stream item#8 =1 Federal-funded #item 28 should be “01”; if Funding stream item#8 =2 state funded, #28 should be 03. "]
[null,2,"there is at least one head-of-household (or spouse of the head-of-household) (item#38 =1 or 2) receiving assistance(item#30=1), item#28 can’t be = “02”. \nCorrection: If number of months countable toward federal time limit (item#44) more than 60 months, #item 28 should be “07”; if less than or equal to 60 months item#28 should be “01”."]
[null,3,"item #28 = “03” or “06” but funding stream (item #8) is not “02”. \nCorrection: If number of months countable toward federal time limit (item#44) more than 60 months, #item 28 should be “07”; if less than or equal to 60 months item#28 should be “01”."]
[null,4,"item #28 = “04” but the number of countable months (item#44) is greater than 60. \nCorrection: item#28 should be “09”"]
[null,5,"If item #28 = “07”, “08” but the number of countable months (item#44) is less than or equal to 60. \nCorrection: item#28 should be “01”. \nIf item#28=”09” and number of months countable toward federal time limit (item#44) less than or equal to 60 months. Correction: item#28 should be “04”"]
[]
[]
[null,"Note: Corrections are how OFA handles the errors"]

{"sheet":"TL_Report_4_Over60Months","index":15,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[6,3,6,7],[7,3,7,7],[8,3,8,7],[9,3,9,7],[12,1,12,2]]}
[]
[null,"Name ","file type","Notes"]
[null,"TIMELIMXX_FY202Y","pdf","Table 4 -list of cases that had 60+ months"]
[]
[]
[null,"Variables"]
[null,"RPT_MONTH_YEAR","=","Report year and month"]
[null,"STRATUM","=","Stratum"]
[null,"CASEID","=","Case Number"]
[null,"FED_Months","=","Months Received Fed Assistance"]
[null,"TLEX1-TLEX4,","=","Time-limit exempt"]
[null," TLEX6-TLEX9"]
[null,"XX: Fips_code of state"]

{"sheet":"invalid_SSNs","index":16,"n_rows":16,"n_cols":9,"rows_kept":16}
[]
[null,"TANF adult recipients with invalid SSN",{"$nulls":4},"TANF Child recipients with invalid SSN"]
[null,"State: xxxxxxxxx in FY2025",{"$nulls":4},"State: xxxxxxxxx in FY2025"]
[]
[null,"CASE_NUMBER","SSN","DATE_OF_BIRTH",null,null,"CASE_NUMBER","SSN","DATE_OF_BIRTH"]
[null,1000007,"000000000",19910414,null,null,1500006,"98T456789",20080101]
[null,1300003,"999999999",19990101,null,null,27800008,"000230000",20251201]
[null,2890002,"666006789",19850516,null,null,2890002,"666006789",20240516]
[null,3800001,"000000000",19890429,null,null,3800001,"000000000",20200429]
[null,30504008,"999999999",19780316,null,null,30504008,"999999999",20230316]
[null,305000003,"000000000",19800502]
[null,345600001,"999999999",19960811]
[null,"xxxxxxx1","000000000",19830722]
[null,"yyyyyyy2","888888888",19710528]
[null,"zzzzzzz3","123456789",19830829]
[null,"tttttttttttt8","999999999",19740217]

{"sheet":"Invalid_age","index":17,"n_rows":13,"n_cols":10,"rows_kept":13}
[]
[]
[]
[]
[]
[]
[null,"TANF adult recipients with invalid DOB or age<12",{"$nulls":4},"TANF child recipients with invalid DOB or age>19"]
[null,"State: xxxxxxxx in FY2026",{"$nulls":4},"State: xxxxxxxx in FY2026"]
[]
[null,"RPT_MONTH_YEAR","CASE_NUMBER","min_age","DATE_OF_BIRTH",null,"RPT_MONTH_YEAR","CASE_NUMBER","min_age","DATE_OF_BIRTH"]
[null,202511,1050000001,10.1,20150918,null,202511,1050000001,19.1,20050918]
[null,202512,2005000002,".",19041302,null,202512,2005000002,20.5,20041210]
[{"$nulls":6},202512,2005000002,".",20241232]